UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KwdNqYhoORlJovahpns+2CiVfTBMk0+A9+svi44mDZU='
WHERE
key_id = '9471fcfdecb59d380b7f78ebe1ad6f0b0408f9d680b783b86446cc0aa8bc9a1b'
AND (
token = 'KwdNqYhoORlJovahpns+2CiVfTBMk0+A9+svi44mDZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)