UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4am0vQO1IU3uEZXRtkJi38IXqYZx8x4/Iw00OmabI3k=' 
WHERE 
  key_id = '3b9d60ee2693fd8bd231cca65ef1f3d8b3ec1c3277ca93dd2cdb8ecd9d212f4a' 
  AND (
    token = '4am0vQO1IU3uEZXRtkJi38IXqYZx8x4/Iw00OmabI3k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044