UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'F7Sw0uw100G2PPsNW+PoKhKPuzQLL/9C+0tQp59nP2I=' 
WHERE 
  key_id = 'b2ffac5a82a8aa7718c7fe13436912ed78d956462875886166d44a7cc277738c' 
  AND (
    token = 'F7Sw0uw100G2PPsNW+PoKhKPuzQLL/9C+0tQp59nP2I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020