UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dEf2Oc+t4gsNw73CKyb0jQvQXbG3sT4GoaabEygGWAw=' 
WHERE 
  key_id = 'ad98d0d3149ded49b8d8076fa2616c8ed95973b913d56840b5d88ced6ed27cb3' 
  AND (
    token = 'dEf2Oc+t4gsNw73CKyb0jQvQXbG3sT4GoaabEygGWAw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024