UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4y9V7ieKgVITDed9z5BKWQuexuEiuN1iqT890eIBsM='
WHERE
key_id = 'e36bb3b7e9b2b10f9e02a429d44a38b13c2ca5d0dec6d90f06c470735024e52f'
AND (
token = 'J4y9V7ieKgVITDed9z5BKWQuexuEiuN1iqT890eIBsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)