UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1/b0hqLxotuy5n0X5eUyCS2Jym73PZSqPY1d33jGA8='
WHERE
key_id = '4243b3031bcb54faadbdd7c33639854c707b35e664e6e704c1494ca95158cebc'
AND (
token = 'C1/b0hqLxotuy5n0X5eUyCS2Jym73PZSqPY1d33jGA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)