UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27VM8DFYfByn5AH9dCln+JC3RI8v/gXvITJ2cjE/5vw='
WHERE
key_id = '1f3b570b771c3d10e3432b18f2e21b69d148f937b7431d1a44f160ce852197a8'
AND (
token = '27VM8DFYfByn5AH9dCln+JC3RI8v/gXvITJ2cjE/5vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)