UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xAAckDog3gIwOmfVdQAsec6ggAicLlldk+AJQT4xiws=' 
WHERE 
  key_id = '65df43183f837b8a6bfa59e605fc83feb7474141e1435c5e4b867fb3ea57886b' 
  AND (
    token = 'xAAckDog3gIwOmfVdQAsec6ggAicLlldk+AJQT4xiws=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029