UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxUc+bbD0diIsb4bXpXBeZDRKhGpHhXdE4NAb9Cy1tY='
WHERE
key_id = 'aed7fd1420e87abd95fc89bea29615b012b735e52f7add711a3f1e0222cef43d'
AND (
token = 'NxUc+bbD0diIsb4bXpXBeZDRKhGpHhXdE4NAb9Cy1tY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)