UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xpf+/SuKTpa5RLS1EC4IbohFlVd8+FKV4FanJgNkp+4='
WHERE
key_id = 'd14de2f70c5a4080642911a6ef87e81354b79c278ec5f1f0fc099a3e632a742b'
AND (
token = 'xpf+/SuKTpa5RLS1EC4IbohFlVd8+FKV4FanJgNkp+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)