UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'z+8QBhwhUnqEjPb5PxSWwXXPr4R3/5hgQ3OXktbI5Aw=' 
WHERE 
  key_id = 'a8239d1119f1b0d5d166352dc9134feaec9c50d93fd57c11fa302da7adc05a64' 
  AND (
    token = 'z+8QBhwhUnqEjPb5PxSWwXXPr4R3/5hgQ3OXktbI5Aw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026