UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NjhQkA88PqGJ6ey5AAmj65YNMZQY98gZ8F10P+zWng0='
WHERE
key_id = '3136c9bc99ad637e3c4a646ffe731167dda31611cc0e3c974e68fec01c77dbbe'
AND (
token = 'NjhQkA88PqGJ6ey5AAmj65YNMZQY98gZ8F10P+zWng0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)