UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWKL6Nu4VxuW76f3pe0A73rOn3XPU2Ti/s5BkbmlZOE='
WHERE
key_id = 'e0ffe1ce618a5cbdff6308834558471f6811dc0b2771566b3c2707170f80fba9'
AND (
token = 'XWKL6Nu4VxuW76f3pe0A73rOn3XPU2Ti/s5BkbmlZOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)