UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfHhiUBOhLpjglho9s3YgJC07oG/UC+cjHlwT4TCZOE='
WHERE
key_id = 'e565107c1cd6b01315b3f75347ff1dadfd6be59197698c73a82833c9bb72f845'
AND (
token = 'NfHhiUBOhLpjglho9s3YgJC07oG/UC+cjHlwT4TCZOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)