UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6URHBoOgF/mwTMqiRd2s6nZhCRhixKRb5G7HqIhTLMA='
WHERE
key_id = '19b7f14d7a45a0fdd50c2e9f23018c941af3a4aace4a9d1c7f5e6e82c6c7eaf2'
AND (
token = '6URHBoOgF/mwTMqiRd2s6nZhCRhixKRb5G7HqIhTLMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)