UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wa8rTAATgvYI2QBcvm/osfci52jvBW9lDESqYAYDLFA='
WHERE
key_id = '3f06e71c365f7684675a7095b6bd65127dcaf76578d8ea3dabf0a8ec4996380d'
AND (
token = 'Wa8rTAATgvYI2QBcvm/osfci52jvBW9lDESqYAYDLFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)