UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZRJ3rmYTpFaZ2wEVnS10ewBgYfgMxOKw7W4qIVD8x94='
WHERE
key_id = '9d35eaaf5a00ab491954ffbd7e7b7597daf7e09862dbc403c4975008cfb20f1e'
AND (
token = 'ZRJ3rmYTpFaZ2wEVnS10ewBgYfgMxOKw7W4qIVD8x94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)