UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dbHMCtnDwmHXKU9Zj2XmZHjEdA0UKjAl7m10a0hG7wo='
WHERE
key_id = '47acaf29d90bc9454c9c05e80ed27292b8f2d5c486755d71ec30c6fa4fb21223'
AND (
token = 'dbHMCtnDwmHXKU9Zj2XmZHjEdA0UKjAl7m10a0hG7wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)