UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9/Zt6049TJy+7CVoQVHT4yVACDxoeW5w8c72Qm5uUSM=' 
WHERE 
  key_id = 'a0c1ce4a35b7b9197a9440abdd5b41da3cf4af3d3b8e8bec09efeb6abf1523d4' 
  AND (
    token = '9/Zt6049TJy+7CVoQVHT4yVACDxoeW5w8c72Qm5uUSM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027