UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FZ4bHkOXATdP6vS7uNE61gF2Ai5M+LIWz9tK+FKMES4='
WHERE
key_id = 'aed20b655e79b78fdd1b341aca0d7f689870f7fb00ce256b1bd4b81cd2ce7f20'
AND (
token = 'FZ4bHkOXATdP6vS7uNE61gF2Ai5M+LIWz9tK+FKMES4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)