UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIRVZacYZr3zkogmhoFJHZs9C6v3BVwnZR4GdMvV6FA='
WHERE
key_id = '4d2106056ee7e4e5156ae54c2c6c41e3f5e15c2a81e8b17be32c61cb30baa7a3'
AND (
token = 'HIRVZacYZr3zkogmhoFJHZs9C6v3BVwnZR4GdMvV6FA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)