UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tyf4ZbUJn897svyLEFxTDcq3LrZWEoErxKXgPxov5gM='
WHERE
key_id = 'c0315e847a87d497c24f6e5ddf59fadd4dea1b142508dbb8e8c1fca67b75424e'
AND (
token = 'tyf4ZbUJn897svyLEFxTDcq3LrZWEoErxKXgPxov5gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)