UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'z2aT8pih/xwjZ6LABs2mvI7Kw9Nci7Zxpq5l2O0fudk=' 
WHERE 
  key_id = '323defb90f722e4bf9c7288b548c1d3e43b3d109aac52fd493c02ef682b4a0bd' 
  AND (
    token = 'z2aT8pih/xwjZ6LABs2mvI7Kw9Nci7Zxpq5l2O0fudk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045