UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i2ro0ILsdEuQ7GGj/Y96tKCjfav6fUnWqZ+H/I5Vwek='
WHERE
key_id = '3f1bd8838fb63cd2343acf8251393946ada32d214d506884dff8bdc967a5aee0'
AND (
token = 'i2ro0ILsdEuQ7GGj/Y96tKCjfav6fUnWqZ+H/I5Vwek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)