UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QOkKqyFen0K0CqcXEdD04Do4Jhw4AAdzkQWwDeOWqI='
WHERE
key_id = '1d47e95e90eda350b3f6633502395dad6d46d17a0de2ace8a7275159b62e092e'
AND (
token = '4QOkKqyFen0K0CqcXEdD04Do4Jhw4AAdzkQWwDeOWqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)