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

Query time 0.00034