UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTcZZIH/l3/qH4vH94NQJ9Ky/tpXYQ7Kqa5IYY50A5I='
WHERE
key_id = '3b16a8e9fe8b5bc8b9b988d02951efe5a059e54892c9e832ac8063a695b117d0'
AND (
token = 'zTcZZIH/l3/qH4vH94NQJ9Ky/tpXYQ7Kqa5IYY50A5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)